SET identity_insert [dbo].[Incidents]  ON

INSERT 
[dbo].[Incidents] 
([DepartmentType], [Id], [CityId], [CallNumber], [Phone], [UnmaskedPhone], [Title], 
[ReceivedTime], [Address], [ReportingParty], [UnmaskedReportingParty], 
[Description], [UpdateDescription], [Longitude], [Latitude], 
[IsHighPriority], [IncidentCategory], [SearchAreaId]) 
SELECT 2, 265, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 632-0744', N'Stray dog', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'2641 Wesley Ave, Berwyn, IL 60402', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', -87.79063, 41.84235, 0, 2, NULL UNION ALL
SELECT 2, 269, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 152-2957', N'Vandalism', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'3278 S Archer Ave, Chicago, IL 60608', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', -87.67108, 41.8346, 0, 5, NULL UNION ALL
SELECT 2, 290, 25, N'201-4387', N'(11) XXX-XXXX', N'(11) 259-3903', N'Poisoning', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Roodepoort, Gauteng, South Africa', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 27.94973, -26.20019, 0, 5, NULL UNION ALL
SELECT 2, 266, 24, N'201-4390', N'(312) XXX-XXXX', N'(312) 703-6896', N'House on fire', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Street, Forest Park, IL 60130', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', -87.81477, 41.86179, 0, 5, NULL UNION ALL
SELECT 2, 262, 24, N'201-4387', N'(312) XXX-XXXX', N'(312) 359-7314', N'Poisoning', CAST(N'2017-01-26T12:21:58.767' AS DateTime), N'Street, Chicago, IL 60618', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', -87.71844, 41.93424, 0, 5, NULL UNION ALL
SELECT 2, 321, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 984-662', N'Stray dog', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Rödelheimer Landstraße 35, 60487 Frankfurt', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 8.62734, 50.12096, 0, 2, NULL UNION ALL
SELECT 2, 349, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 124-1039', N'Stray dog', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Timber Ln, Falls Church, VA 22046', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', -77.19252, 38.88313, 0, 2, NULL UNION ALL
SELECT 2, 377, 28, N'201-4390', N'XXXX-XXXX', N'1030-6733', N'Stray dog', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Quality Rd, Singapore, Singapore', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 103.71102, 1.33364, 0, 2, NULL UNION ALL
SELECT 2, 405, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0017-4800', N'Stray dog', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'1st Block, Jayanagar, Bengaluru 560011, India', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 77.58809, 12.94023, 0, 2, NULL UNION ALL
SELECT 2, 293, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 896-0043', N'Stray dog', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Shaft 17 Rd, Johannesburg, 2013, South Africa', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 27.97908, -26.22964, 0, 2, NULL UNION ALL
SELECT 2, 433, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 2282-6925', N'Stray dog', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Peschiera, Lomb., Italy', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 9.2786, 45.43658, 0, 2, NULL UNION ALL
SELECT 2, 461, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 570-6044', N'Stray dog', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Transformatorweg, 1014 Amsterdam, Netherlands', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 4.85023, 52.39194, 0, 2, NULL UNION ALL
SELECT 2, 489, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 972-4199', N'Stray dog', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'27 Morley Road, Ward End, B8 2', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', -1.82957, 52.49458, 0, 2, NULL UNION ALL
SELECT 2, 517, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 833-554', N'Stray dog', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Drejervej 16, 2400 København NV, Denmark', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 12.53388, 55.70258, 0, 2, NULL UNION ALL
SELECT 2, 545, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 4370-6926', N'Stray dog', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Dongjak-gu Bon-dong 474-1', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', 126.95009, 37.51648, 0, 2, NULL UNION ALL
SELECT 2, 573, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 849-2498', N'Stray dog', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'228th Ave NE, Sammamish, WA 98074', N'Raymond XXXXX', N'Raymond Sam', N'Stray dog acting aggressively towards civilians', N'', -122.035515, 47.61563, 0, 2, NULL UNION ALL
SELECT 2, 402, 29, N'201-4387', N'(80) XXXX-XXXX', N'(80) 0527-8725', N'Poisoning', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Hennur Main Road, Richards Town, Cooke Town, Bengaluru 560005, India', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 77.62179, 13.00632, 0, 5, NULL UNION ALL
SELECT 2, 406, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0826-2516', N'House on fire', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'8 1st C Cross Road, Sudhama Nagar, Bengaluru 560027, India', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 77.58875, 12.95772, 0, 5, NULL UNION ALL
SELECT 2, 518, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 395-193', N'House on fire', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Ydergrænsen 6, 2600 Ejby, Denmark', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 12.42664, 55.70375, 0, 5, NULL UNION ALL
SELECT 2, 521, 33, N'201-4390', N'(78) XXX-XXX', N'(78) 552-236', N'Vandalism', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2300 København S, Denmark', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 12.53509, 55.62143, 0, 5, NULL UNION ALL
SELECT 2, 542, 34, N'201-4387', N'(2) XXXX-XXXX', N'(2) 1361-0722', N'Poisoning', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu yongsan-dong 2-ga 3-2', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 126.98002, 37.54071, 0, 5, NULL UNION ALL
SELECT 2, 546, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 7081-7767', N'House on fire', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Jongno-gu Pyeongchang-dong 148-33', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 126.97153, 37.60743, 0, 5, NULL UNION ALL
SELECT 2, 409, 29, N'201-4390', N'(80) XXXX-XXXX', N'(80) 0266-7255', N'Vandalism', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'31 4th Cross Road, Cholara Palya, Vijayanagar, Bengaluru 560023, India', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 77.547, 12.9709, 0, 5, NULL UNION ALL
SELECT 2, 549, 34, N'201-4390', N'(2) XXXX-XXXX', N'(2) 4076-9250', N'Vandalism', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Gangnam-gu Apgujeong-dong 435', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 127.02611, 37.52919, 0, 5, NULL UNION ALL
SELECT 2, 574, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 14-7871', N'House on fire', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'24092 SE 12th Pl, Sammamish, WA 98075', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', -122.055887, 47.588534, 0, 5, NULL UNION ALL
SELECT 2, 570, 35, N'201-4387', N'(555) XXX-XXXX', N'(555) 471-8674', N'Poisoning', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Pine Lake Park, 2401 228th Ave Se, Sammamish, WA  98075', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', -122.037877, 47.5877, 0, 5, NULL UNION ALL
SELECT 2, 577, 35, N'201-4390', N'(555) XXX-XXXX', N'(555) 272-5058', N'Vandalism', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Ebright Creek Park, 1389 212th Ave SE, Sammamish, WA 98075', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', -122.05807, 47.597675, 0, 5, NULL UNION ALL
SELECT 2, 294, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 465-9841', N'House on fire', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'2001, Gauteng, South Africa', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 27.95226, -26.22468, 0, 5, NULL UNION ALL
SELECT 2, 297, 25, N'201-4390', N'(11) XXX-XXXX', N'(11) 292-1904', N'Vandalism', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Johannesburg, 2198, South Africa', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 28.09073, -26.18333, 0, 5, NULL UNION ALL
SELECT 2, 318, 26, N'201-4387', N'(69) XXX-XXX', N'(69) 435-980', N'Poisoning', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Hafenstraße & Mannheimer Straße, 60327 Frankfurt', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 8.65772, 50.10361, 0, 5, NULL UNION ALL
SELECT 2, 322, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 779-616', N'House on fire', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Broßstraße 12, 60487 Frankfurt', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 8.65102, 50.12926, 0, 5, NULL UNION ALL
SELECT 2, 325, 26, N'201-4390', N'(69) XXX-XXX', N'(69) 837-740', N'Vandalism', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Heinz-Raspe-Platz, 60314 Frankfurt', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 8.71982, 50.11296, 0, 5, NULL UNION ALL
SELECT 2, 346, 27, N'201-4387', N'(202) XXX-XXXX', N'(202) 967-5352', N'Poisoning', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'4185 Linnean Ave NW, Washington, DC 20008', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', -77.05492, 38.9443, 0, 5, NULL UNION ALL
SELECT 2, 353, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 265-8718', N'Vandalism', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'654 6th St SE, Washington, DC 20003', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', -76.99814, 38.88158, 0, 5, NULL UNION ALL
SELECT 2, 350, 27, N'201-4390', N'(202) XXX-XXXX', N'(202) 928-3410', N'House on fire', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'6th St NW, Washington, DC 20001', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', -77.01999, 38.91554, 0, 5, NULL UNION ALL
SELECT 2, 374, 28, N'201-4387', N'XXXX-XXXX', N'4755-9617', N'Poisoning', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Central Catchment Reserve, Singapore', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 103.78893, 1.36934, 0, 5, NULL UNION ALL
SELECT 2, 381, 28, N'201-4390', N'XXXX-XXXX', N'8239-3111', N'Vandalism', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'24 Jalan Kuak, Singapore 577794, Singapore', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 103.84059, 1.35419, 0, 5, NULL UNION ALL
SELECT 2, 378, 28, N'201-4390', N'XXXX-XXXX', N'5075-5682', N'House on fire', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 104.02604, 1.34401, 0, 5, NULL UNION ALL
SELECT 2, 430, 30, N'201-4387', N'(911) XXXX-XXXX', N'(911) 6065-3906', N'Poisoning', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Cascina Anguria, 20011 Corbetta MI', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 8.93511, 45.45292, 0, 5, NULL UNION ALL
SELECT 2, 437, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 9021-0803', N'Vandalism', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Luigi Pirandello 6, 20093 Cologno Monzese MI', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 9.29263, 45.52374, 0, 5, NULL UNION ALL
SELECT 2, 434, 30, N'201-4390', N'(911) XXXX-XXXX', N'(911) 6388-5147', N'House on fire', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Street, 20080 MI', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 8.96663, 45.42425, 0, 5, NULL UNION ALL
SELECT 2, 458, 31, N'201-4387', N'(85) XXX-XXXX', N'(85) 127-5807', N'Poisoning', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Lekstraat 9-1, 1079 EK Amsterdam, Netherlands', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 4.90824, 52.34528, 0, 5, NULL UNION ALL
SELECT 2, 462, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 788-8950', N'House on fire', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Akerpolderstraat 4, 1066 ET Amsterdam, Netherlands', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', 4.79704, 52.3417, 0, 5, NULL UNION ALL
SELECT 2, 465, 31, N'201-4390', N'(85) XXX-XXXX', N'(85) 242-2586', N'Vandalism', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Amstelveenseweg, 1076 Amsterdam, Netherlands', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', 4.85755, 52.34305, 0, 5, NULL UNION ALL
SELECT 2, 486, 32, N'201-4387', N'(871) XXX-XXXX', N'(871) 425-3391', N'Poisoning', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'11 Westbourne Road, Edgbaston, B15 3', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', -1.93058, 52.46661, 0, 5, NULL UNION ALL
SELECT 2, 490, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 246-9995', N'House on fire', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Friary Gardens, Handsworth, B21 8', N'Samantha XXXXX', N'Samantha Smith', N'House fire reported', N'', -1.94136, 52.51659, 0, 5, NULL UNION ALL
SELECT 2, 493, 32, N'201-4390', N'(871) XXX-XXXX', N'(871) 6-7975', N'Vandalism', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Dunvegan Road & Bracadale Avenue, Erdington, B24 9', N'Magnus XXXXX', N'Magnus Hedlund', N'Vandalism reported in park, trash can set on fire, police and fire requested', N'', -1.83411, 52.52386, 0, 5, NULL UNION ALL
SELECT 2, 514, 33, N'201-4387', N'(78) XXX-XXX', N'(78) 429-903', N'Poisoning', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2860 Søborg, Denmark', N'Prakash XXXXX', N'Prakash Paramasivam', N'Someone poisoned the water hole.', N'', 12.46916, 55.73237, 0, 5, NULL
GO